package itsm.isperp.module.repository.incident;

import itsm.isperp.framework.data.mybatis.dao.CUDMapper;
import itsm.isperp.module.entity.app.AppUser;
import itsm.isperp.module.entity.incident.IcdCategoryRelamembers;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

/**
 * 数据访问
 * 
 * @author lizx
 * @date 2015-04-03 09:37
 */
@Repository
public interface IcdCategoryRelamembersMapper extends CUDMapper<IcdCategoryRelamembers> {

	/**
	 * 查询事件类别关联的工程师
	 * 
	 * @param categoryId
	 *            事件类别ID
	 * @return 关联工程师列表
	 */
   List<Map<String, Object>> getIcdCategoryRelamembers(@Param("categoryId") String categoryId);
   
   void deleteByRelateId(@Param("id") String id);
   
   List<Map<String, Object>> findAllMemberByCategoryId(@Param("categoryId") String categoryId,@Param("userProcessSql") String userProcessSql);
   
   List<AppUser> findRelaAppUserByCategoryIdAndRole(@Param("categoryId") String categoryId,@Param("roleName") String roleName);
   
   

}


